﻿CREATE TABLE [dbo].[Log]
(
	[ServiceLogId] BIGINT NOT NULL PRIMARY KEY, 
    [ServerName] NVARCHAR(255) NULL, 
    [ServerIP] NVARCHAR(50) NULL, 
    [ContextID] UNIQUEIDENTIFIER NULL, 
    [ClientName] NVARCHAR(255) NULL, 
    [ClientIP] VARCHAR(50) NULL, 
    [UserID] NVARCHAR(50) NULL, 
    [ServiceID] NVARCHAR(500) NULL, 
    [StartDateTime] DATETIMEOFFSET NULL, 
    [EndDateTime] DATETIMEOFFSET NULL, 
    [State] NCHAR(10) NULL, 
    [InputMessageId] BIGINT NULL, 
    [OutputMessgeId] BIGINT NULL
)
